gsm_external_xref table — gsmex
This table defines generic cross-reference information to details in external tables.
For example, an organization whose accounts are held in the database might have other account codes in an external database from which the account codes originated. This table could be used to define which internal accounts point to which external accounts for cross-referencing and reporting purposes. In this example, the fields are set up as follows:
- Related entity — The
gsm_organization table in the database.
- Related object — Specific organizations.
- Internal entity — The
gsm_account table in the database.
- Internal object — Specific account codes.
Table 4–19 lists the table’s FLA, fields, and foreign keys.
Table 4–19: gsm_external_xref table information
|
Table FLA
|
Fields (data type)
|
Foreign keys
|
|
gsmex
|
related_entity_mnemonic (Character)
related_owning_obj (Decimal)
internal_entity_mnemonic (Character)
internal_owning_obj (Decimal)
external_xref_obj (Decimal)
external_entity_mnemonic (Character)
external_owning_obj (Decimal)
external_code (Character)
external_description (Character)
external_details (Character)
|
None
|
Table 4–20 gives details of the table’s indexes.
Table 4–20: gsm_external_xref index information
|
Index name
|
Elements
|
Type
|
|
XPKgsm_external_xref
|
related_entity_mnemonic
related_owning_obj
internal_entity_mnemonic
internal_owning_obj
external_xref_obj
|
Primary Unique
|
|
XIE1gsm_external_xref
|
related_entity_mnemonic
related_owning_obj
internal_entity_mnemonic
external_owning_obj
|
Nonunique
|
|
XIE2gsm_external_xref
|
related_entity_mnemonic
related_owning_obj
internal_entity_mnemonic
external_code
|
Nonunique
|
|
XIE3gsm_external_xref
|
related_entity_mnemonic
related_owning_obj
internal_entity_mnemonic
external_description
|
Nonunique
|
|
XIE4gsm_external_xref
|
related_entity_mnemonic
related_owning_obj
internal_entity_mnemonic
external_details
|
Nonunique
|
|
XIE5gsm_external_xref
|
external_entity_mnemonic
external_owning_obj
|
Nonunique
|
|
XIE6gsm_external_xref
|
external_code
|
Nonunique
|
|
XIE7gsm_external_xref
|
external_xref_obj
|
Nonunique
|
If an external table is available, then the external entity and object can be defined, otherwise the external details are keyed directly into this table.